﻿
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sproc_Flow_AddFile]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[sproc_Flow_AddFile];
GO
CREATE PROCEDURE [dbo].[sproc_Flow_AddFile]
    @DocID int,
    @FileName nvarchar(255),
    @FileSize int,
    @FileAttribute int,
    @FileVisualPath nvarchar(255),
    @FileAuthor nvarchar(255),
    @FileCatlog nvarchar(255),
    @FileAddedDate datetime
    
AS
BEGIN
SET NOCOUNT ON;

INSERT INTO dbo.uds_Flow_Files (DOCID, [FILENAME], FILESIZE, FILEATTRIBUTE, FILEVISUALPATH, FILEAUTHOR, FILECATLOG, FILEADDEDDATE)
VALUES(@DocID, @FileName, @FileSize, @FileAttribute, @FileVisualPath, @FileAuthor, @FileCatlog, @FileAddedDate)

RETURN @@identity;

END
GO